<?php 

 //employees_spec for employeeNumber

 //employees_spec for employeeNumber
$employees_spec["employeeNumber"] ["show"] = 1;
$employees_spec["employeeNumber"] ["edit"] = 0;
$employees_spec["employeeNumber"] ["key"] = 1;
$employees_spec["employeeNumber"] ["filter"] = 1;
$employees_spec["employeeNumber"] ["sort"] = 1;
$employees_spec["employeeNumber"] ["size"] = 20;
$employees_spec["employeeNumber"] ["rows"] = 1;
$employees_spec["employeeNumber"] ["date_show_format"] = "yyyy-mm-dd";
$employees_spec["employeeNumber"] ["date_source_format"] = "yyyy-mm-dd";
$employees_spec["employeeNumber"] ["source"] = "employees";
$employees_spec["employeeNumber"] ["edit_as"] = "ctl_text";

 //employees_spec for lastName

 //employees_spec for lastName
$employees_spec["lastName"] ["show"] = 1;
$employees_spec["lastName"] ["key"] = 0;
$employees_spec["lastName"] ["edit"] = 1;
$employees_spec["lastName"] ["filter"] = 1;
$employees_spec["lastName"] ["sort"] = 1;
$employees_spec["lastName"] ["size"] = 20;
$employees_spec["lastName"] ["rows"] = 1;
$employees_spec["lastName"] ["date_show_format"] = "yyyy-mm-dd";
$employees_spec["lastName"] ["date_source_format"] = "yyyy-mm-dd";
//$employees_spec["lastName"] ["source"] = "employees";
$employees_spec["lastName"] ["edit_as"] = "ctl_text";
$employees_spec["lastName"] ["showfilter"] = 1;

 //employees_spec for firstName

 //employees_spec for firstName
$employees_spec["firstName"] ["show"] = 1;
$employees_spec["firstName"] ["edit"] = 1;
$employees_spec["firstName"] ["key"] = 0;
$employees_spec["firstName"] ["filter"] = 1;
$employees_spec["firstName"] ["sort"] = 1;
$employees_spec["firstName"] ["size"] = 20;
$employees_spec["firstName"] ["rows"] = 1;
$employees_spec["firstName"] ["date_show_format"] = "yyyy-mm-dd";
$employees_spec["firstName"] ["date_source_format"] = "yyyy-mm-dd";
$employees_spec["firstName"] ["source"] = "employees";
$employees_spec["firstName"] ["edit_as"] = "ctl_text";

 //employees_spec for extension

 //employees_spec for extension
$employees_spec["extension"] ["show"] = 1;
$employees_spec["extension"] ["key"] = 0;
$employees_spec["extension"] ["edit"] = 1;
$employees_spec["extension"] ["filter"] = 1;
$employees_spec["extension"] ["sort"] = 1;
$employees_spec["extension"] ["size"] = 20;
$employees_spec["extension"] ["rows"] = 1;
$employees_spec["extension"] ["date_show_format"] = "yyyy-mm-dd";
$employees_spec["extension"] ["date_source_format"] = "yyyy-mm-dd";
$employees_spec["extension"] ["source"] = "employees";
$employees_spec["extension"] ["edit_as"] = "ctl_text";

 //employees_spec for email

 //employees_spec for email
$employees_spec["email"] ["show"] = 1;
$employees_spec["email"] ["key"] = 0;
$employees_spec["email"] ["edit"] = 1;
$employees_spec["email"] ["filter"] = 1;
$employees_spec["email"] ["sort"] = 1;
$employees_spec["email"] ["size"] = 20;
$employees_spec["email"] ["rows"] = 1;
$employees_spec["email"] ["date_show_format"] = "yyyy-mm-dd";
$employees_spec["email"] ["date_source_format"] = "yyyy-mm-dd";
$employees_spec["email"] ["source"] = "employees";
$employees_spec["email"] ["edit_as"] = "ctl_text";

 //employees_spec for officeCode

 //employees_spec for officeCode
$employees_spec["officeCode"] ["show"] = 1;
$employees_spec["officeCode"] ["key"] = 0;
$employees_spec["officeCode"] ["edit"] = 1;
$employees_spec["officeCode"] ["filter"] = 1;
$employees_spec["officeCode"] ["sort"] = 1;
$employees_spec["officeCode"] ["size"] = 20;
$employees_spec["officeCode"] ["rows"] = 1;
$employees_spec["officeCode"] ["date_show_format"] = "yyyy-mm-dd";
$employees_spec["officeCode"] ["date_source_format"] = "yyyy-mm-dd";
$employees_spec["officeCode"] ["source"] = "employees";
$employees_spec["officeCode"] ["edit_as"] = "ctl_select";
$employees_spec['officeCode'] ['list'] = array(0=>array('keyvalue'=>0,'showvalue'=>'none'));
$employees_spec['officeCode'] ['listquery'] = "SELECT officeCode AS keyvalue, city AS showvalue FROM offices WHERE 1 ";
$employees_spec['officeCode'] ['listqueryorder'] = array('city'=>'ASC');
$employees_spec["officeCode"] ["showfilter"] = 1;
$employees_spec['officeCode'] ['defaultfornull'] = 3;
 //employees_spec for reportsTo
$employees_spec["reportsTo"] ["show"] = 1;
$employees_spec["reportsTo"] ["key"] = 0;
$employees_spec["reportsTo"] ["edit"] = 1;
$employees_spec["reportsTo"] ["filter"] = 1;
$employees_spec["reportsTo"] ["sort"] = 1;
$employees_spec["reportsTo"] ["size"] = 20;
$employees_spec["reportsTo"] ["rows"] = 1;
$employees_spec["reportsTo"] ["date_show_format"] = "yyyy-mm-dd";
$employees_spec["reportsTo"] ["date_source_format"] = "yyyy-mm-dd";
$employees_spec["reportsTo"] ["source"] = "employees";
$employees_spec["reportsTo"] ["edit_as"] = "ctl_select";
$employees_spec["reportsTo"] ["listquery"] = "SELECT employeeNumber AS keyvalue, lastName AS showvalue FROM employees WHERE 1 ";
$employees_spec['reportsTo'] ['listqueryorder'] = array('lastName'=>'ASC');

 //employees_spec for jobTitle

 //employees_spec for jobTitle
$employees_spec["jobTitle"] ["show"] = 1;
$employees_spec["jobTitle"] ["key"] = 0;
$employees_spec["jobTitle"] ["edit"] = 1;
$employees_spec["jobTitle"] ["filter"] = 1;
$employees_spec["jobTitle"] ["sort"] = 1;
$employees_spec["jobTitle"] ["size"] = 20;
$employees_spec["jobTitle"] ["rows"] = 1;
$employees_spec["jobTitle"] ["date_show_format"] = "yyyy-mm-dd";
$employees_spec["jobTitle"] ["date_source_format"] = "yyyy-mm-dd";
$employees_spec["jobTitle"] ["source"] = "employees";
$employees_spec["jobTitle"] ["edit_as"] = "ctl_text";

 //employees_spec for fulltime

 //employees_spec for fulltime
$employees_spec["fulltime"] ["show"] = 1;
$employees_spec["fulltime"] ["key"] = 0;
$employees_spec["fulltime"] ["edit"] = 1;
$employees_spec["filltime"] ["edit"] = 1;
$employees_spec["fulltime"] ["filter"] = 1;
$employees_spec["fulltime"] ["sort"] = 1;
$employees_spec["fulltime"] ["size"] = 20;
$employees_spec["fulltime"] ["rows"] = 1;
$employees_spec["fulltime"] ["date_show_format"] = "yyyy-mm-dd";
$employees_spec["fulltime"] ["date_source_format"] = "yyyy-mm-dd";
$employees_spec["fulltime"] ["source"] = "employees";
$employees_spec["fulltime"] ["edit_as"] = "ctl_checkbox";

 //employees_spec for hiredate

 //employees_spec for hiredate
$employees_spec["hiredate"] ["show"] = 1;
$employees_spec["hiredate"] ["key"] = 0;
$employees_spec["hiredate"] ["edit"] = 1;
$employees_spec["hiredate"] ["sort"] = 1;
$employees_spec["hiredate"] ["size"] = 20;
$employees_spec["hiredate"] ["rows"] = 1;
$employees_spec["hiredate"] ["date_show_format"] = "yyyy-mm-dd";
$employees_spec["hiredate"] ["date_source_format"] = "yyyy-mm-dd";
//$employees_spec["hiredate"] ["source"] = "employees";
$employees_spec["hiredate"] ["edit_as"] = "ctl_jqdate";
$employees_spec['hiredate'] ['filter'] ['before']['op'] = '<';
$employees_spec['hiredate'] ['filter'] ['after']['op'] = '>=';
$employees_spec['hiredate'] ['filter'] ['after']['show'] = 1;

//column settings for delete
$employees_spec['edit'] ['show'] = 1;
$employees_spec['edit'] ['size'] = 20;
$employees_spec['edit'] ['rows'] = 1;
$employees_spec['edit'] ['makefunction'] = 'make_edit';

//column settings for delete
$employees_spec['delete'] ['show'] = 1;
$employees_spec['delete'] ['size'] = 20;
$employees_spec['delete'] ['rows'] = 1;
$employees_spec['delete'] ['headname'] = 'Delete';
$employees_spec['delete'] ['makefunction'] = 'make_delete';


//column settings for Select
$employees_spec['Select'] ['show'] = 0;
$employees_spec['Select'] ['size'] = 20;
$employees_spec['Select'] ['rows'] = 1;
$employees_spec['Select'] ['makefunction'] = 'make_multiselectCB';

 ?>